{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Event Budget"],"not_rendered":{"charts":1,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Event Budget","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,4,0,9],[4,4,4,9],[18,4,18,9],[26,0,26,2],[32,0,32,2],[10,4,10,9],[11,4,11,9],[17,4,17,9]]}
["Expenses",null,null,null,"Income"]
[null,"Estimated","Actual",null,null,"Estimated","Actual"]
[null,{"$f":"SUM(B11,B18,B26,B32,B39)","v":5550},{"$f":"SUM(C11,C18,C26,C32,C39)","v":4515},null,null,{"$f":"SUM(I10,I17,I24)","v":5675},{"$f":"SUM(J10,J17,J24)","v":6675}]
[]
[null,null,null,null,"Registration"]
["Site","Estimated","Actual",null,"Estimated #","Actual #","Items","Revenue per","Estimated","Actual"]
["Room Rental",2500,2250,null,65,60,"Regular",15,{"$f":"E7*H7","v":975},{"$f":"F7*H7","v":900}]
["Site staff",0,0,null,25,30,"Students",20,{"$f":"E8*H8","v":500},{"$f":"F8*H8","v":600}]
["Audio Visual",500,0,null,10,15,"Other",5,{"$f":"E9*H9","v":50},{"$f":"F9*H9","v":75}]
["Furniture",0,0,null,{"$f":"SUM(E7:E9)","v":100},{"$f":"SUM(F7:F9)","v":105},null,null,{"$f":"SUM(I7:I9)","v":1525},{"$f":"SUM(J7:J9)","v":1575}]
["Total",{"$f":"SUBTOTAL(109,Table1[Estimated])","v":3000},{"$f":"SUBTOTAL(109,Table1[Actual])","v":2250}]
[null,null,null,null,"Exhibitors"]
["Food & Beverage","Estimated","Actual",null,"Estimated #","Actual #","Items","Revenue per","Estimated","Actual"]
["Breakfast",2000,1890,null,5,6,"Large booths",500,{"$f":"E14*H14","v":2500},{"$f":"F14*H14","v":3000}]
["Lunch ",0,0,null,4,5,"Medium booths",300,{"$f":"E15*H15","v":1200},{"$f":"F15*H15","v":1500}]
["Break 1",0,0,null,3,4,"Small booths",150,{"$f":"E16*H16","v":450},{"$f":"F16*H16","v":600}]
["Break 2",0,0,null,{"$f":"SUM(E14:E16)","v":12},{"$f":"SUM(F14:F16)","v":15},null,null,{"$f":"SUM(I14:I16)","v":4150},{"$f":"SUM(J14:J16)","v":5100}]
["Total",{"$f":"SUBTOTAL(109,Table5[Estimated])","v":2000},{"$f":"SUBTOTAL(109,Table5[Actual])","v":1890}]
[null,null,null,null,"Miscellaneous"]
["Program","Estimated","Actual",null,"Estimated #","Actual #","Items","Revenue per","Estimated","Actual"]
["Speaker fees / honoraria",0,0,null,0,0,"Sponsorships",0,{"$f":"E21*H21","v":0},{"$f":"F21*H21","v":0}]
["Speaker Travel & Living",100,100,null,0,0,"SURA",0,{"$f":"E22*H22","v":0},{"$f":"F22*H22","v":0}]
["Speaker Gifts",250,200,null,0,0,null,0,{"$f":"E23*H23","v":0},{"$f":"F23*H23","v":0}]
["Program Brochure",0,0,null,{"$f":"SUM(E21:E23)","v":0},{"$f":"SUM(F21:F23)","v":0},null,null,{"$f":"SUM(I21:I23)","v":0},{"$f":"SUM(J21:J23)","v":0}]
["Other",0,0]
["Total",{"$f":"SUBTOTAL(109,Table6[Estimated])","v":350},{"$f":"SUBTOTAL(109,Table6[Actual])","v":300}]
[]
["Registration","Estimated","Actual",null,null,null,null,null,"Type","Estimated","Actual"]
["Registration service fees",0,0,null,null,null,null,null,"Income",{"$f":"F3","v":5675},{"$f":"G3","v":6675}]
["Badges",100,50,null,null,null,null,null,"Expenses",{"$f":"B3","v":5550},{"$f":"C3","v":4515}]
["Attendee Kits/Gifts",0,0,null,null,null,null,null,"P&L",{"$f":"SUM(J29:J30)","v":11225},{"$f":"SUM(K29:K30)","v":11190}]
["Total",{"$f":"SUBTOTAL(109,Table3[Estimated])","v":100},{"$f":"SUBTOTAL(109,Table3[Actual])","v":50}]
[]
["Miscellaneous","Estimated","Actual"]
["Committee Expenses",100,25]
["Transportation",0,0]
[]
[]
["Total",{"$f":"SUBTOTAL(109,Table4[Estimated])","v":100},{"$f":"SUBTOTAL(109,Table4[Actual])","v":25}]